SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004928 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004928 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (637496,236158,479761,900214,721645,907007,129511,475660,820383,864935,1026556,104623,787549,489431,410471,455045,722056,543814,461190,746569,862989,148227,352004,853484,938138,215283,195766,352595,927957,566747,900423,605831,328274,158829,115790,222733,279158,286703,569344,358674,1045836,38658,329012,650288,579082,319172,201933,608804,728382,710233,546914,558958,188563,89415,366029,233296,56593,270733,691148,284759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]