SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001538s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477914 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477914 [ RunTime:0.003790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798893,867626,632215,793429,622519,467527,447904,813529,120786,775567,950563,321169,325121,255880,697778,180951,657763,873161,45513,81339,606850,140252,542071,627467,45759,477513,1035425,248479,881184,326888,440702,197733,388097,455480,331649,623933,83097,774896,848905,200483,571159,783027,754277,304847,405613,458249,29389,118699,152707,467927,200401,836982,1010974,86360,335637,111856,778056,499948,903321,156751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]