SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423108 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423108 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512586,948893,777031,200606,163642,374620,412362,114687,336326,1027778,278498,168990,184242,160823,329775,20419,841714,433154,46586,586222,666407,964054,156223,622317,215165,526519,598677,220187,108036,928583,17345,43056,787700,447436,865790,254309,558795,964942,443475,78919,790448,847155,350139,1033269,989522,1021177,117805,942245,483924,622025,520892,823850,465621,869105,37029,373849,360898,253105,498896,280715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]