SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532804 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532804 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209656,114235,461580,625984,836030,320815,519193,542349,187148,405101,232647,797907,380987,313086,750217,280836,337903,711457,390826,575594,516431,224199,266316,985690,1004026,129461,633273,856662,634071,650465,770356,686646,534562,70993,130715,311327,343625,235205,431980,876742,314062,889349,264007,60809,366285,359326,549899,788404,834157,1044311,129919,165438,467827,417939,314684,788563,504345,412361,744866,299478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]