SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342716 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342716 [ RunTime:0.002270s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298647,755661,145251,213081,800243,325738,767329,243687,994726,561251,267600,87132,91638,602222,197556,315928,1048297,226053,920991,505805,989188,998793,821173,48128,1630,895041,754109,469190,223638,732102,155009,44351,275243,956040,803229,380536,492442,585976,196011,635406,322994,76213,649284,560295,944709,17177,409792,428563,496184,937000,587832,653991,404662,967604,19208,332064,150907,591497,811181,296536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]