SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002030s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023142 LIMIT 1 [ RunTime:0.001703s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023142 [ RunTime:0.008024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819529,978859,745024,193473,926232,810114,22047,772051,228972,1007698,348286,95209,69630,444990,977996,582761,621067,278400,800714,990844,455245,164634,862338,805399,14313,964569,994663,381479,522175,822064,708599,176949,14233,867291,926017,939351,40858,530190,706772,717845,60509,54094,621803,317417,69128,159409,424422,272944,706980,779059,818025,216142,882524,109601,423170,857541,356786,365448,629923,630272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]