SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283394 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283394 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396373,499459,791935,198493,669736,972071,843495,282779,749356,449784,526681,671644,172583,336049,316799,168930,1007232,429434,872746,47270,974259,7679,611207,961372,270356,327958,732469,292520,846046,596539,718901,261195,643167,260581,133195,386025,750368,228190,214860,261924,385888,950105,332567,127276,295615,658592,190887,970932,946990,769006,571902,5538,904776,222335,392670,418810,698104,83616,813959,527217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000389s ]