SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001078 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001078 [ RunTime:0.003787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917577,20951,614179,125546,204084,916733,128978,63477,33550,230555,518623,757723,813363,277543,548637,987739,139649,144043,640661,920844,168055,701077,485611,1038923,560910,748062,316041,529519,284241,271135,640624,535552,609196,144857,622400,208804,503872,73504,145828,852545,183118,454321,414373,141771,317708,938509,302377,567379,537511,699369,629763,823513,617879,58799,793249,782986,246543,560569,767445,926507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001310s ]