SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547475 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547475 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215041,179647,640108,443436,972124,421017,196695,76826,1047684,363262,835729,319538,647676,852772,56588,163540,843862,546485,781373,919819,725324,681450,708038,178765,102459,549925,798189,142250,445802,532198,318402,755762,137472,857940,293237,663701,795272,410713,824562,477937,108314,655335,179381,902351,51028,270891,876687,246244,520057,929334,897781,1041375,306011,256689,129534,1028815,644956,100121,441321,554304) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]