SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495223 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495223 [ RunTime:0.002422s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301222,609927,1002190,872241,105266,586092,11612,560371,214973,47873,401433,698968,1006063,556320,116363,273742,817273,246999,316343,920098,190018,807346,814592,838553,705216,575494,875347,941654,957903,604426,251430,412842,37048,342995,845718,512727,632093,622137,955457,593333,642755,84044,296635,736986,412220,712240,253118,771499,365640,910849,715494,508960,1018462,34267,220357,961446,669879,415118,919949,473437) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002942s ]