SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026467 LIMIT 1 [ RunTime:0.003776s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026467 [ RunTime:0.002629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248787,120285,640346,851768,838425,668867,703822,1024241,544101,552279,173610,345233,859578,267841,728024,881886,892361,900701,397379,166359,11329,755961,765684,1037245,536676,445067,863425,886267,58641,949937,298582,921775,63366,920306,383589,454755,845713,566975,539914,1039496,511775,573178,33220,519094,579382,540320,297276,366286,293126,719483,944292,481803,699858,136586,30270,242230,506077,41607,86141,26002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002819s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026467 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026467 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000927s ]