SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494323 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494323 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841237,416113,210046,1010089,677397,530231,296016,823454,59300,372625,755867,852858,884337,567927,870395,173850,133081,9346,277732,876371,830323,91519,843224,429698,524369,787250,411278,170160,179407,6582,502362,292066,534867,201641,6652,118025,320986,950048,773906,901398,979779,513467,1046810,241695,1009251,430433,717933,408740,884082,644416,252146,458340,296682,364894,823221,87306,563548,269446,314875,552710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]