SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406404 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406404 [ RunTime:0.003195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608350,455617,914306,139733,553434,137939,744453,1029151,994524,637554,406246,745887,207393,322167,790931,422185,347182,763810,185118,979920,983583,343440,463094,84143,589219,574054,318894,914259,233185,1011636,663509,666939,537155,635111,957596,496167,348119,618649,599771,51809,137718,110512,153535,474189,784999,892984,320587,638116,737361,545399,367674,735780,908829,764454,90590,918790,220596,485877,1004386,761744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]