SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 558568 LIMIT 1 [ RunTime:0.001234s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 558568 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380030,420816,203232,2954,221458,335475,755754,1038005,553465,477075,138680,265511,311277,496045,916469,536678,477775,1017566,89911,133189,402199,125519,831112,591413,922104,819754,1003416,851400,779880,169336,790440,33945,497456,73328,339805,957690,200500,35256,881709,520834,518926,741350,55275,850479,318335,527630,402298,484971,828525,496818,175383,936626,495666,204622,246794,732285,778624,881527,259990,548185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 558568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 558568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]