SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531895 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531895 [ RunTime:0.002087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645330,577011,285383,77933,1005024,50928,519625,305197,371800,936191,210060,920563,468187,601289,90460,272423,306831,572227,60896,298265,350528,427164,222407,254879,742712,44849,114388,876495,60404,298667,1021844,38996,438498,739680,256757,395729,881239,78770,1027577,517295,788645,1003641,1003995,979950,977922,901604,276743,1035646,451951,150542,286993,232447,928186,467712,752635,870818,402843,554687,815587,127549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531895 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531895 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]