SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406007 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406007 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445059,42607,542941,366083,847615,231806,724773,35867,225365,310556,518081,720006,461277,846014,939730,391599,834010,374913,791823,1030403,346924,772594,202837,479660,781401,164071,191882,710718,92748,770497,810793,1004613,423353,952126,32096,915976,108133,687704,425981,1000635,496642,756045,747097,72158,424753,673145,517681,613787,1005690,128736,277795,511912,798020,128541,603271,205419,945047,41915,214245,801167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001273s ]