SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519971 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519971 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945418,1047001,323266,767700,1040233,485154,894495,390200,935103,678712,50891,879178,69525,664432,142025,473671,569427,711123,770942,365727,645682,592451,609431,561569,1000944,278532,412122,232727,928108,357987,678577,302360,481397,766405,564191,372690,412792,760801,75359,636495,485307,510420,665211,452710,129073,146325,366320,997677,1000180,34293,855186,314069,342445,338613,864238,349199,5045,1003944,546775,1028869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]