SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407996 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407996 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121651,763208,721019,561529,820419,403450,1040985,312664,259342,60478,408658,999457,177489,846180,646865,3386,780052,1010399,455111,446556,349268,721135,820609,889798,438113,906565,611759,21175,794739,854300,996896,659463,864877,552386,192945,12348,20215,321758,801855,797420,464142,225830,616656,123979,554070,172633,592752,962115,477740,589636,178896,267639,472700,855513,105764,163501,793518,1029286,613840,878668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]