SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003310 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003310 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664268,623916,452165,745107,185230,149147,1015556,924901,583115,605528,509940,528701,449190,30625,766704,282642,412589,353798,104530,897848,22359,723415,943438,583922,778777,140224,180210,495081,138340,906556,322173,351472,133851,444085,824570,84762,623124,980257,778127,792998,367854,714900,969101,960172,163659,598685,790294,712509,822975,659483,31295,849350,798771,981528,1001752,769009,955318,552459,348201,582188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]