SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269319 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269319 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417572,1016307,852434,52449,1027516,420109,95668,878238,160363,1031596,246077,1001506,595813,104007,5381,126432,779772,46577,817316,277500,33933,742374,1016726,335171,28850,613964,880331,406086,803007,823670,37412,676489,486405,650990,247183,137870,460700,183548,1037150,625925,414228,535960,449295,484087,108917,945339,687594,272882,678338,1020933,727100,515684,834047,560086,12562,360483,927866,325056,966682,830695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]