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` = 318991 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318991 [ RunTime:0.006790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404625,767630,473357,113203,989082,106938,579323,966743,214221,708340,942959,625136,644679,64788,655691,928881,734961,288495,91141,734267,4209,399430,698580,731694,720504,27763,152664,275978,942463,6756,898263,540120,441003,897940,660368,315217,1018464,565545,341856,342940,137192,535802,614186,597983,165122,131083,824139,513629,237085,536938,867072,83581,489319,612724,583084,255408,128501,223895,231365,5782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]