SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001723 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001723 [ RunTime:0.002248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120084,412807,685300,483936,960664,237785,546191,1036975,283010,347058,101022,863155,603769,119534,716523,360789,192314,284155,338722,477980,169457,955987,861501,455555,747534,70085,1003993,625089,263130,525242,556437,938841,594731,508174,259101,202827,185173,550132,254242,552173,93283,213472,148843,977763,765030,782981,328452,800130,319582,407336,338255,924279,638382,253300,737466,734504,974853,393895,42899,928899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]