SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142215 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142215 [ RunTime:0.004014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002689,634330,547720,805720,311450,607249,620740,869161,233936,420968,797833,203310,455617,112577,1001993,26450,289623,738363,252264,766838,701602,1029484,227518,611901,430464,748980,692765,554229,351869,478096,632484,601242,740711,902046,99223,348114,955459,600840,654873,373669,17480,286046,85567,897396,383178,446431,535948,464820,269952,308106,468015,587127,290165,713337,266408,238892,181243,481452,328429,78910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001668s ]