SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310681 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310681 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (157002,842495,548876,633335,318111,302699,85329,936419,558298,7717,396900,761900,27919,25855,404158,607755,588346,217503,362091,702211,501580,787523,508321,440963,1004486,188947,242675,1012441,97993,1657,448066,706647,416106,167248,129583,969475,796858,172216,1020698,300883,836765,126353,1018900,650974,367238,769107,324904,880210,939315,92881,296956,13619,465554,534912,60527,734626,403517,986687,844818,1000188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]