SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526519 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526519 [ RunTime:0.002781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608012,844599,168143,676894,230608,803027,711002,30254,200478,282986,158767,803022,959599,621694,223758,263788,54379,611738,707431,563424,970386,697029,185934,93643,237428,7494,798782,999425,497090,476159,584304,977901,865544,328533,513389,83001,891694,686714,647288,339201,906002,832748,657740,807105,844859,163588,692999,340561,175614,155456,1039145,341684,306519,421542,822876,55661,479782,613482,811994,593637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526519 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526519 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]