SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513489 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513489 [ RunTime:0.002148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296720,215582,292854,1006329,238470,391497,782319,581630,876226,762281,963427,884387,670788,62917,987361,141944,983403,477249,570694,217073,312604,953645,365986,76123,146462,167300,836906,499952,225270,265677,508054,1006137,775726,1034507,609845,115378,607987,148401,464507,37991,544075,975074,981076,316502,229839,414774,709781,67151,290855,164895,45094,962289,796850,994637,137877,46290,1040595,974409,511482,756052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]