SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513436 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513436 [ RunTime:0.002458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263291,509678,774491,498233,219653,92645,54157,575944,985105,532978,491405,760680,725359,838166,294912,500647,307436,558997,163611,421340,157501,574141,177453,436407,556663,36162,973561,844924,824833,113596,286368,405268,1020142,901666,397971,38071,126502,225398,987713,699321,923024,611578,534166,458628,979872,317907,452297,57783,729122,528063,964948,1022299,716878,467665,1027733,217872,88862,251463,737529,57788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]