SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546343 LIMIT 1 [ RunTime:0.000841s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546343 [ RunTime:0.003532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319346,762828,800679,118163,804182,502900,897645,292918,272017,244928,639054,36287,652272,599694,936643,610085,930960,890575,293883,139738,506714,93413,328767,503098,845967,756671,721819,832003,699486,614855,276269,219705,736486,761258,653637,738226,481589,947983,130043,41046,679114,711834,295106,401588,513787,277763,774801,761977,700306,487658,88344,607204,128328,796344,175341,185713,1037823,773819,501645,103756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]