SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001566s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424063 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424063 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711993,153231,273486,881631,291202,832110,432118,642033,708434,63554,681376,827462,358854,404042,488911,362784,279472,126689,348423,766632,975820,310101,571810,725750,708022,622276,668856,132791,405381,799606,27667,102947,882019,924114,918438,559189,861031,689654,797558,531965,803964,849002,307411,873543,454745,705352,87104,957432,749943,10119,436547,229250,222210,405354,599806,541490,107535,52448,874279,963249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]