SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40452 LIMIT 1 [ RunTime:0.002472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40452 [ RunTime:0.003599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449979,435495,943080,214450,901093,63399,673316,701765,853236,600683,64442,297708,973581,812903,976616,450339,1020577,893657,1048848,851767,770484,593443,320748,873936,413700,937725,805697,794223,609496,735515,478506,143308,19064,489224,766594,338523,23420,141782,142839,570085,865304,165082,152308,656982,1025863,572085,779655,310649,94466,308235,949783,937543,384874,914422,991040,751431,729993,647796,391879,587067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]