SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984080 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984080 [ RunTime:0.004181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333807,168309,443033,593049,910491,120426,388960,992216,305566,926497,755372,794333,581576,97422,3155,137944,979711,935534,690109,226558,489720,135783,809303,28237,461691,145932,339010,113449,108156,816455,738144,374136,502375,80961,440914,826586,777181,228921,223042,237086,844213,739213,980738,782048,819344,322246,521099,943493,879063,790677,260902,701123,228121,776444,190977,683638,621569,849249,223555,784708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003732s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001837s ]