SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506694 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506694 [ RunTime:0.006361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968605,36159,42509,420554,704531,100887,783275,506376,796901,122511,620773,364495,553866,369542,929002,320831,900145,236707,413161,653070,798938,1047658,214302,947783,317382,137381,883245,616210,608861,305456,1004760,79121,688292,883798,975677,702217,450696,115246,269766,307891,781744,76070,233218,299571,996840,295201,587373,181435,401120,956361,358526,1016636,946554,808575,505503,516074,852671,230479,19287,23999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]