SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001510s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471611 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471611 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514991,1042155,724765,780271,355319,525200,130878,420284,678135,1002827,792305,45833,299899,1043408,11898,634613,36270,561004,449665,414332,575192,890006,51091,146306,792222,134415,481360,539958,124109,876906,318703,1006574,598515,744629,626561,706316,335871,801898,439057,344960,1008923,108134,606939,314563,1000603,264504,484220,1004928,415265,869722,104959,1048801,644964,58151,454503,304434,15188,561690,286664,1026336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]