SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460427 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460427 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421142,41660,154524,608282,291248,891397,592563,373183,8148,380905,860179,368505,347124,443603,933796,234261,700963,365390,1025262,885912,871576,367348,828687,951454,319893,499273,1012789,441753,700551,1011624,809309,578528,458971,443573,115435,442268,444802,511496,576172,1018255,854035,428636,581379,12689,271833,364579,547534,514098,254855,567100,889548,690939,228741,835736,614466,840391,942479,295826,566605,699833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000698s ]