SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019692 LIMIT 1 [ RunTime:0.000598s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019692 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945928,322510,785649,860860,331814,768998,312046,969220,427506,647656,267018,873911,695548,56671,93791,441591,710996,839149,517615,114592,956584,663549,987827,934905,315350,689645,939080,206785,287817,294315,787721,478615,1032404,583756,2975,442011,910541,50705,445694,122266,994766,454520,495695,479122,643938,346875,62551,918786,862590,503440,915414,351493,48939,51595,903074,714001,111469,491126,429505,84166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019692 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019692 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]