SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504370 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504370 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911411,555914,1007731,297481,387584,825472,323013,389942,509257,536439,457786,887964,802367,960869,14050,574846,542346,374833,130008,964282,509492,525879,137391,1048420,42001,1025519,547471,981276,1041796,877818,187003,372691,780838,968863,647916,709156,76043,508002,262953,596889,419984,37184,31137,847305,697072,1044815,479227,342803,577387,135221,1238,778994,11818,140404,370393,46175,833113,782991,946889,778214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001228s ]