SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390575 LIMIT 1 [ RunTime:0.000623s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390575 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141106,82728,557865,145000,481463,253248,801978,994619,596123,188570,189116,865172,176443,1002550,946262,969949,349412,388714,44118,427722,370750,971256,627630,955884,842661,432101,742233,123967,1003813,136997,634363,514192,146740,405724,955285,200522,338,757334,351948,188516,37030,220578,735499,1037572,279830,819959,442109,432,489155,15051,677825,720478,179858,632983,168268,461508,775551,875105,838252,763959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]