SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003685s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535548 LIMIT 1 [ RunTime:0.002131s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535548 [ RunTime:0.005449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557834,849618,187739,121152,584457,626633,878541,1032578,767265,770757,399256,935796,805502,773918,84459,570850,1015196,175753,680077,769875,716449,322467,846306,1004951,446707,726390,799527,19900,884849,10320,780148,248345,252609,24592,529444,294555,215909,540499,469838,343644,1006392,595808,860890,854853,1031691,889414,387752,846379,648976,183275,136749,735466,650229,160320,339551,374004,117721,989108,944174,738330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000397s ]