SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103931 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103931 [ RunTime:0.003800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68965,46496,320161,39067,174016,132160,456821,10532,334501,68150,820868,1017517,904893,194440,784389,236370,411986,973789,1020697,754364,457510,72441,83083,453336,974875,379423,1040601,79446,960877,823231,403520,304031,322897,124345,972039,802554,676876,55660,1007370,353533,176182,1023292,763994,245628,420257,203729,213427,1024381,50719,920337,544379,6478,432287,314792,933661,1023822,227521,802700,246396,24826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001829s ]