SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 628180 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 628180 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150004,270680,956968,153001,198540,812244,960330,116743,352499,866736,270015,424960,907336,824423,626645,813110,824028,561745,89803,1031393,900650,913701,172589,1033604,865371,172424,122317,493181,664696,440505,923651,1033271,995213,671925,585421,929713,1019119,453488,287065,943645,909127,638711,798556,775804,967572,164804,32270,632960,954889,290565,51534,911976,915998,195671,80405,156818,292728,675200,429,451466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 628180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 628180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]