SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50641 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50641 [ RunTime:0.002038s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226910,472380,835510,593291,262140,1015995,703994,929717,387433,509257,604292,778961,28005,100606,394751,563490,963704,707845,294658,887398,385751,287667,722116,905513,952231,6393,986558,416716,638040,812079,292936,950053,948656,728352,496217,566279,579452,706547,854388,338032,57970,355152,179425,25615,484234,313469,267045,986340,519138,478781,320521,899855,645106,370283,280126,86193,397039,501020,450972,200970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]