SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338210 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338210 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (973933,843566,552772,477023,331661,470291,556371,22145,688358,107345,50440,597043,475141,758080,111180,156944,774950,997478,951130,54294,210331,778897,1007243,980981,480237,24603,524974,343595,681648,1019252,1041706,637551,1038723,87897,219697,174624,296137,570545,154247,744531,347191,820670,39999,553511,566840,62817,130645,895020,353013,676927,929218,872245,747135,67833,13153,115895,22778,615798,472717,36370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]