SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385398 LIMIT 1 [ RunTime:0.003351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385398 [ RunTime:0.004366s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417838,635468,847539,953386,732363,583869,133633,919426,346891,503641,531238,688804,168422,582702,868833,448099,745246,336971,713415,84389,150828,811928,594162,938199,576292,344614,882909,645024,542182,306575,591073,637932,962416,797869,955271,683135,75969,503531,119049,273023,11220,273973,340755,76457,375226,747363,283085,248554,825098,635193,42855,874793,633920,690968,190794,113511,691888,936563,714797,896192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]