SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422948 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422948 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (859692,520488,880081,546703,249700,932197,562519,217135,555421,229473,19278,606531,643909,403750,453245,52667,371751,571392,947223,875245,789134,857414,840865,955317,142075,251312,123787,12644,337959,818557,582743,608347,529656,616184,743480,1014255,78895,885381,180249,731694,115491,408069,819142,813197,219207,966,555317,1040924,2428,918339,558501,842362,646467,102500,579487,947990,532772,25701,743328,255903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]