SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504179 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504179 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250895,513673,812680,355920,64115,311824,109404,62973,713726,563235,754492,566218,306404,399757,284224,769724,74718,238155,584359,417749,855118,43751,726309,471680,578566,427164,379531,827117,544227,1018467,246704,1023903,942263,268746,765835,1005365,805960,444557,705652,492993,851935,23496,814157,747496,6867,299118,518137,373351,882358,508439,249162,546494,79867,878008,553133,708456,391969,927081,579248,568051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]