SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415696 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415696 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54079,326693,1041077,1017129,254312,315070,809578,114925,258776,663472,384944,708994,478610,463395,871138,460090,139309,147263,21855,542887,771082,649869,783413,194141,978223,421065,393522,290308,935101,567949,619366,1033976,197378,1044562,948330,928070,744357,185349,439519,398304,877314,268493,266625,927020,576825,221467,1014979,276623,656445,385345,424822,173372,440013,890842,854770,801320,921375,289489,897643,797759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415696 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415696 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]