SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291596 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291596 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284582,408449,490618,407317,949973,396512,46280,1021282,1006685,970815,765756,1034785,858134,800464,389988,91803,46768,993214,486162,899050,354743,1003595,415575,14752,202951,830142,610388,461790,53305,352863,449559,646635,713380,365146,857967,521471,622952,638009,213226,176267,670260,169575,837148,156934,454146,444330,228067,94955,390704,66071,7265,730339,112892,533758,95244,830612,589195,672922,441448,770944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]