SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420080 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420080 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651469,588888,332807,890533,363762,357389,935166,856191,543862,971811,604468,765815,887129,453210,370111,82128,116599,360213,1005324,721672,476644,928363,360246,653454,316993,269351,60151,78763,1031329,702771,460276,781073,35496,430837,954559,244941,897534,539584,549338,370803,440063,24416,301245,546557,191597,556249,980292,738313,471177,644420,832612,963642,301091,348377,631069,405840,309864,188319,655588,140858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]