SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340019 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340019 [ RunTime:0.002090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799017,279474,46619,67159,152714,29901,870860,173333,158890,417149,193800,558452,891900,752555,549252,3848,346256,73505,592596,766138,1046911,836568,808331,476400,12602,830504,482983,442187,804300,500380,810930,814740,356352,956718,488120,265555,116412,311290,768111,967927,821918,430397,988342,751134,870174,985411,584584,995502,535842,1037600,98003,357771,450979,7171,515361,776468,151296,846488,615320,859566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]