SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 929180 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 929180 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218873,641818,897235,510798,24994,930332,123556,860888,508296,564393,225793,1012718,740594,131784,550232,505836,369593,886304,273048,582640,607549,889802,233852,898387,755316,515367,505852,994558,840361,170267,325619,388260,505338,788918,734854,460953,976770,1033045,339732,61176,162913,43807,402467,648661,829450,256710,531001,884626,994768,371982,1000314,349438,816671,924394,21152,779731,868156,29663,505806,343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 929180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003871s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 929180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]