SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396781 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396781 [ RunTime:0.002711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692591,1033143,317212,212042,763603,239335,247557,100008,184440,542858,979332,850672,389708,966453,199329,636997,552434,792142,266097,556567,782089,481876,1025747,928696,463573,404901,108384,1034917,278218,451270,865907,982205,539183,736953,679473,433963,204824,180827,5011,475844,581644,728384,974364,455772,237451,34476,136759,367201,709061,742870,132876,8234,460816,499133,139382,300802,952795,57324,258849,819206) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001397s ]