SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504053 LIMIT 1 [ RunTime:0.001465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504053 [ RunTime:0.002221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619545,725705,577096,341536,389291,638427,1027005,392153,1048913,942199,138110,727896,529775,770250,467052,726374,333409,212217,498142,101686,806561,790854,532494,79865,503466,970609,908107,428654,543676,352417,1006366,814526,843371,462751,699604,902339,278932,678837,550486,295070,649192,911418,737011,257837,804182,134871,218597,752022,194210,43963,164109,1036479,1048684,963122,493309,412330,58511,847091,18333,472495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]