SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105918 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105918 [ RunTime:0.002171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132425,643864,375876,326166,451435,135541,1023063,900742,178058,433371,445383,97689,58543,770572,253742,745064,203607,516976,117985,29375,925142,597176,266656,467505,993156,753151,933084,789043,425455,797375,714233,942549,303482,546464,333582,111079,334902,533858,434073,352985,737215,552356,510814,105002,809340,1003787,880373,843273,617203,433037,685744,360480,137739,809412,957194,947548,597994,510088,550152,391076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]