SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036373 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036373 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426911,309239,664180,474550,354399,407914,811858,73953,737246,646575,35918,955756,940881,11809,350471,159356,1028798,35618,616115,616654,995291,620325,879907,731591,95094,951376,26223,538322,269096,370804,599925,997330,602859,32713,501019,616377,74662,674297,665747,29927,456504,595363,554573,394256,970691,460166,453895,547033,790456,751109,280705,525259,40458,497036,477771,295502,52535,555125,717506,952038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036373 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036373 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001382s ]