SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 645063 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 645063 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670913,897323,451691,98269,75906,387370,886620,133879,907572,249883,443140,523867,864134,619000,20111,413408,72705,707924,712409,184576,773498,512133,801132,120344,233244,890933,999346,544404,606180,124980,818397,945855,776813,43578,97155,18322,826390,325024,8011,241459,102438,882184,69107,967328,256711,97434,671870,744072,77365,940630,1048080,650717,66045,908241,449266,699030,80615,146212,43896,352019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 645063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 645063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]