SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304981 LIMIT 1 [ RunTime:0.000664s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304981 [ RunTime:0.002182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515228,224671,485720,822046,966578,549667,397972,271395,776004,934853,814360,910020,255985,964142,169344,523871,216877,161222,101618,911021,1044827,23552,71190,267428,679923,3123,856034,182955,391088,614539,1029391,658938,994271,364535,317909,512931,134729,811949,314523,324357,945800,111827,387200,901485,710119,938907,458651,159916,952853,900961,22450,738305,764329,692669,847769,654670,513862,841255,769089,458430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000883s ]