SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520246 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520246 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695718,458537,342327,390091,552257,311713,936148,690570,885503,801901,1008220,672802,133659,122510,99835,541639,732169,122895,918506,85384,106628,110101,970022,574320,748798,198370,290680,628951,736956,201554,444700,1004661,35034,559389,47364,271222,390015,352036,486462,935848,875145,910224,574141,905773,741320,958984,720777,534022,244946,84729,493340,642287,133633,952741,309424,764706,466924,758300,333680,1011719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]