SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201704 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201704 [ RunTime:0.002346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194798,577335,234350,436676,662598,411586,1037305,769549,961136,29433,381925,638035,413304,801724,142940,874270,3533,684380,480569,396107,979523,330220,874832,186550,1021520,105983,472992,60830,808580,113131,576431,846994,492852,66930,179599,347917,361621,24363,404454,661224,6026,690234,527044,379929,742336,309557,461519,468406,526588,639107,29723,297857,610827,395352,1035224,199325,430,533393,802339,145377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000770s ]