SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002419s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40920 LIMIT 1 [ RunTime:0.004433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40920 [ RunTime:0.006048s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291748,266134,50953,995720,929817,803638,248089,896896,211288,444209,218034,1044293,394961,425509,1044567,282035,249805,617008,428741,212518,326341,459748,527410,167913,87686,619825,763279,460502,779606,463992,205049,367827,450119,189440,832838,320965,261344,203197,471063,412599,460083,426969,303219,54576,569126,128107,341320,996075,904713,676845,755493,67532,254237,384175,700721,734220,1048826,765366,13485,396345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005058s ]