SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197827 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197827 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429649,251745,301080,84796,548430,760349,681980,687422,983705,120846,111248,331803,909139,781986,65244,767097,705066,750311,942115,962585,37708,382638,741543,429457,83331,722998,223610,945468,928470,829508,120971,117,614239,741351,1026021,443527,770469,301865,841265,906997,47991,65685,137681,531618,241740,209239,1041372,674789,369193,277095,497977,945060,32356,995692,973056,874066,612908,308603,409208,547104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197827 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197827 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]