SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543243 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543243 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681931,1036773,385327,494896,343400,236392,292763,885365,80031,802736,525420,196091,513325,920891,912101,149926,312806,226265,569698,99968,757148,542584,814642,247095,731751,493378,393275,90245,472566,932843,830578,607171,932591,41882,289866,593181,1010305,722286,936060,314668,231692,378661,258035,270788,355436,104013,954911,949446,348920,254509,909567,483262,326977,736618,699902,469027,679470,444056,858956,136470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]