SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011478 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011478 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (976501,614337,427056,725608,971722,698514,253169,104386,59734,472767,58057,482517,853222,379551,973008,959530,846049,402895,544123,937665,352921,54793,559429,316825,257026,854284,939591,271250,542247,535410,619121,377114,900650,180814,31742,847229,252932,216552,905341,41627,1018935,610865,952462,413228,193885,158339,865679,137031,77217,270982,645586,707817,273453,389374,1010297,1002454,1040011,851646,550204,1003141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]