SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465840 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465840 [ RunTime:0.002485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (766519,1104,521257,216321,373885,711560,282313,525965,912789,838016,215321,434435,318313,269111,600566,431080,435982,939064,323175,933762,390416,274563,653511,88450,967287,357350,39153,539123,573400,107595,401503,466041,384823,166491,800216,671756,607297,547325,119234,608574,185196,143283,47287,144435,534931,689569,634943,380327,395551,1044632,225635,510693,133333,489644,24710,461198,546244,825432,382975,722213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]