SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546511 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546511 [ RunTime:0.003767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465931,361896,859236,979867,889579,96756,463342,395453,618333,466256,105103,563588,647796,1013896,199248,704587,326321,264968,557049,1036398,682349,889086,214789,142792,632050,375085,301462,945481,110912,707041,781927,407988,133132,387340,585551,477498,13285,60088,658475,931189,462520,11015,854943,19428,724322,285782,406192,343951,866664,372682,1031285,520912,576734,373106,70100,407143,131937,882420,919653,14588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001558s ]