SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427343 LIMIT 1 [ RunTime:0.000488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427343 [ RunTime:0.002435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50896,509917,204877,725972,488958,849549,750905,717192,475769,487256,568198,474450,779608,1041159,460927,90208,51056,102923,896639,736581,128220,465863,954812,139645,1015949,677581,808315,324978,989725,158330,647498,805057,753763,62191,145456,9242,53227,761387,159901,1009251,434873,839183,970127,487133,825997,625897,10266,764239,896438,25729,100148,921526,437350,896497,1008793,113652,409247,544524,639066,177282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]