SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005499s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443930 LIMIT 1 [ RunTime:0.001014s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443930 [ RunTime:0.004150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043718,64439,3470,9952,877575,899839,532340,613616,537728,669850,209768,624762,687931,619329,470261,116006,510807,136920,745235,92339,157629,66002,721263,433361,801216,333835,325182,914299,905080,56409,593199,361780,500298,820472,692628,97387,760018,454435,178401,142953,746852,67153,466199,780769,642161,880408,107887,173898,420149,911530,139496,1030597,118435,370126,295919,178957,356461,1000180,865596,571657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003096s ]